UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W9cS9aR8GqjS7/svf3mo/2bXrLnQdOnWdcteL3U52OU='
WHERE
key_id = 'b8234d3f0a531f7ec6796a48c9f9ac91316fe09a920e3968bed1cb3b4981972d'
AND (
token = 'W9cS9aR8GqjS7/svf3mo/2bXrLnQdOnWdcteL3U52OU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)