UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bm9KCo0JVsVgoyDmKLMsC95a2tr+g40ASHP4bfjd2r8='
WHERE
key_id = 'd37d2f7f348f4c156f4105ec94a27918d796fd117f9e02345c610d4d02069837'
AND (
token = 'bm9KCo0JVsVgoyDmKLMsC95a2tr+g40ASHP4bfjd2r8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)