UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U6hgHuITsm0GqqU6yjedpf8opmT1f7tMoj8k7C3aHMM='
WHERE
key_id = '4c971a1cff226bddfd2b62246cc37e0807973f0a6798435852f98fde9d11697d'
AND (
token = 'U6hgHuITsm0GqqU6yjedpf8opmT1f7tMoj8k7C3aHMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)