UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'amXYCPRqEkbM8AA4lJLiHDG2kRZkeJOT3WAkNsNYBLg='
WHERE
key_id = 'e1f0b8374982a47714de573871136935950c58f7e488754ec225b87ac26bf972'
AND (
token = 'amXYCPRqEkbM8AA4lJLiHDG2kRZkeJOT3WAkNsNYBLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)