UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j9gdSVIrejXHEJNc60vCUxsc4uWrkDg+jG1txHB+50Q='
WHERE
key_id = 'a166b638b49dca71fa40be5db09b6ae39a8c976f13828e8d1998ee79fc80c7a7'
AND (
token = 'j9gdSVIrejXHEJNc60vCUxsc4uWrkDg+jG1txHB+50Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)