UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7QFKfFEtAFMfPc7e47iRwc2sO0WdI9henrWZ8SCVFs='
WHERE
key_id = 'bd59c6ee1947985d60dc1696f4d35778b17a7f1c17294f58da3b26f1e84d0789'
AND (
token = 'r7QFKfFEtAFMfPc7e47iRwc2sO0WdI9henrWZ8SCVFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)