UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L1/nXobA9tpeyxhLSdiJFP/mLUQ4wpmFHL8gT7HmmFE='
WHERE
key_id = 'fc1a6aba1741d9f29fdf42202de33d8021034ca2de80d12904dee648e934287a'
AND (
token = 'L1/nXobA9tpeyxhLSdiJFP/mLUQ4wpmFHL8gT7HmmFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)