UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NCX1nhNQHecAyhfOU3pTSo5HcGkk7s54LHneSRrA+WQ='
WHERE
key_id = '0b3e147f82b3fb99bc7c73d8a869a4f50fa3c4d7aabf6d1a8d6f0f7aeb45ac2c'
AND (
token = 'NCX1nhNQHecAyhfOU3pTSo5HcGkk7s54LHneSRrA+WQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)