UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dp/GOb182Jey7QsQsRBDbXbiCP9lkpgMcHJNalxX5C8='
WHERE
key_id = '27b2f4e0cd0fed59e2db5ab7e77f6aade341469b387230494c34e8af11436699'
AND (
token = 'Dp/GOb182Jey7QsQsRBDbXbiCP9lkpgMcHJNalxX5C8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)