UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yH8lBUFwajvnrezE5bUePf2aFDPSydRnQ61MNjSCQ0w='
WHERE
key_id = '48099850708587864ec1f0d1bb5783c15970422834c2b7c0f6d4946ea9f9a4d9'
AND (
token = 'yH8lBUFwajvnrezE5bUePf2aFDPSydRnQ61MNjSCQ0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)