UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vE4JBPzxOkFKXPefTXY7i0Rgdd/foIy4gHzzD28scNw='
WHERE
key_id = 'd13a98fb21002303fe40f27dd604dd17bc3fc86221d8e38da2e7757d9a26e7a6'
AND (
token = 'vE4JBPzxOkFKXPefTXY7i0Rgdd/foIy4gHzzD28scNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)