UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TQiKqcbvHidh6/TaeegygVkp/mGyFkBrOslWQPBlbjM='
WHERE
key_id = '8dfa0532994e257f846790eb0feab825f7290597d0f475d9f3b15fa42122d5c4'
AND (
token = 'TQiKqcbvHidh6/TaeegygVkp/mGyFkBrOslWQPBlbjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)