UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gRrzo6ypUuAlgHCKify5k0z8rEMzxH58hPdJdF0T8LU='
WHERE
key_id = 'ab62a64b38e03add094d365eff8c8b8ef23a70c3c95e0dd93838365be4ebb55b'
AND (
token = 'gRrzo6ypUuAlgHCKify5k0z8rEMzxH58hPdJdF0T8LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)