UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XKf8Ce+3mdJmVivrwcbB9frBGhY+ZO0wVPxtRTakq5Q='
WHERE
key_id = '6e8a9f38aa7de33517a39fed35ececd3987befd56d351c086b96c6321cf380db'
AND (
token = 'XKf8Ce+3mdJmVivrwcbB9frBGhY+ZO0wVPxtRTakq5Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)