UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nF7hU6GsfdSn4K4jj9uSuGlKGXAaBxzji/39x3hJ4sI='
WHERE
key_id = '1eb31052142436917ad9ee3a0cf27f7958b2932ef9252e382dc2250d3878dd80'
AND (
token = 'nF7hU6GsfdSn4K4jj9uSuGlKGXAaBxzji/39x3hJ4sI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)