UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hjDxTj2FHR1OERLvpHAuaUwCLBkzG0bH5xCQzyhV1lA='
WHERE
key_id = '84a7ca4ea488aa11b0fbd1ffc29a39ee6e8c6f28d32f0f1b9de63b13d1d953ac'
AND (
token = 'hjDxTj2FHR1OERLvpHAuaUwCLBkzG0bH5xCQzyhV1lA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)