UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OVzg3Tbq4M1Xg7DG1kweooUFUwBY1avJjOIqOif/pNo='
WHERE
key_id = 'a9dbb8d493a81c04f3655fc48c002166a694ea4a27322f73d0e40f8c05094b54'
AND (
token = 'OVzg3Tbq4M1Xg7DG1kweooUFUwBY1avJjOIqOif/pNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)