UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eicgN8KHtSWJsPo6ofCRz5u6pzwgCMmoqzgZBsVyft0='
WHERE
key_id = 'be78cef3dc45453272f145e64f04a1d69f916a6b5a60d286cd10796607725e9d'
AND (
token = 'eicgN8KHtSWJsPo6ofCRz5u6pzwgCMmoqzgZBsVyft0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)