UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gysgLcKMjPTSxo9bFZvKzJ4EAsmalJyc/VQ+qmbofxo='
WHERE
key_id = '48a4276f2b9336c37badae4815cc4a4d4f7c35450fcc0d40702ad801469df005'
AND (
token = 'gysgLcKMjPTSxo9bFZvKzJ4EAsmalJyc/VQ+qmbofxo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)