UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6CKCz46YkXc6y5vNU6sUQz5RzIfb5ady7OMQhJCdzPU='
WHERE
key_id = '0cdfc20430d3731f0d2e98220114275066b5cdd1cf81caf5d1d309b73e7b6a2f'
AND (
token = '6CKCz46YkXc6y5vNU6sUQz5RzIfb5ady7OMQhJCdzPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)