UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wHvP0xHCxEAss0PfOrNRPNQueViUIzi/HBEr4Zq84Hw='
WHERE
key_id = 'aba941a5c2f602d37c5e2dd6a3065f3fdf0f761cc2f717f6141db8ccf39a4788'
AND (
token = 'wHvP0xHCxEAss0PfOrNRPNQueViUIzi/HBEr4Zq84Hw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)