UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1uEM9Hsf9kcjJJgO7FvSu0d8K4zdakLnL1fKza4rt+g='
WHERE
key_id = 'e98405d70965608f3cbff79c3f18ec76ef83064d42ff78200011bc21929e4701'
AND (
token = '1uEM9Hsf9kcjJJgO7FvSu0d8K4zdakLnL1fKza4rt+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)