UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hHj9YaqCGpQCKRUbDWs2w/7XAwD2ZLZirD8Q1G5KyZE='
WHERE
key_id = '78e6ced588c45f51d49c1527319eb657251b514389536f647830e150748e2f20'
AND (
token = 'hHj9YaqCGpQCKRUbDWs2w/7XAwD2ZLZirD8Q1G5KyZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)