UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KouVlCJbCHH39HvvEnV3WUcbRkPzqpEaGhmlCaifsv4='
WHERE
key_id = '47d0f68bb8feec3c929930cf33182584a184697a5a2845237858e98a71e4e1b9'
AND (
token = 'KouVlCJbCHH39HvvEnV3WUcbRkPzqpEaGhmlCaifsv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)