UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zhq8l2lwYfR1o/F2PvE1PCdgRanKTl4StwPruIADaak='
WHERE
key_id = '5165e52151c99bfc428daf5cd369df881a3646434cba6c3b92081fe5a78c2d2d'
AND (
token = 'Zhq8l2lwYfR1o/F2PvE1PCdgRanKTl4StwPruIADaak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)