UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1iRg6PJ6EAPOgX2ErUYF0q0t4hA07BEJEhQog6oChV8='
WHERE
key_id = 'a3f3b14bd373b8ae52fb268e093f52836e53953445facfc70e07ea39c0a21f60'
AND (
token = '1iRg6PJ6EAPOgX2ErUYF0q0t4hA07BEJEhQog6oChV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)