UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6fet27PHlMXbOO8GTOafYGhgbrbdhyaKudVNqB783eo='
WHERE
key_id = 'b557ac0f46076cf456d5d39f0a20ed1779b2417af65a9a9373cb981d4804096a'
AND (
token = '6fet27PHlMXbOO8GTOafYGhgbrbdhyaKudVNqB783eo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)