UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qXriUVjb8KLMyITEZEpK0t9dtIaxdGtSI3VLrtgqghw='
WHERE
key_id = '3f648a40d09d20cccd00ca173bd395f6dc6fb9cbbf03264d6eff8f358bf8da49'
AND (
token = 'qXriUVjb8KLMyITEZEpK0t9dtIaxdGtSI3VLrtgqghw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)